{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Polecenia","zadanie 1","zadanie 2","zadanie 3","zadanie 4","zadanie 5"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Polecenia","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
["Nr grupy","Nazwisko","Imię","Nr albumu","Data","Nr zadania","Termin","Czas przygotowań [h]"]
[1,null,null,null,"2019-07-02",5,"pierwszy"]
[]
[null,{"$f":"IF(OR(A2=\"\",B2=\"\",C2=\"\",D2=\"\"),\"UZUPEŁNIJ SWOJE DANE!\",\"\")","v":"UZUPEŁNIJ SWOJE DANE!"}]
[]
[null,"Zasady kolokwium:"]
[null,"1. Zadania rozwiązywane SAMODZIELNIE - zabroniony jest kontakt z osobami w laboratorium jak i poza nim."]
[null,"2. Dozwolone materiały pomocnicze: notatki, książki."]
[null,"3. Wyniki należy umieszczać w żółtych polach obok wyszczególnionych statystyk!"]
[null,"4. Nie wolno zaokrąglać wyników!"]
[null,"5. Nie wolno zmieniać nazw istniejących arkuszy ani nazwy pliku."]
[null,"6. Plik należy przesłać do godziny 10:00 na adres Jacek.Szandula@ue.wroc.pl. W tytule maila podać (numer grupy) (przecinek) (spacja) (nazwisko) np.: 12, Kowalski"]
[]
[null,"Po kolokwium:"]
[null,"1. Ze strony szandulajacek.republika.pl należy pobrać plik z rozwiązanymi zadaniami."]
[null,"2. Aby sprawdzić poprawność rozwiązanych zadań należy:"]
[null,null,"a) otworzyć swój plik, przejść do arkusza zadanie 1, skopiować obszar odpowiedzi (czarna ramka), "]
[null,null,"b) otworzyć plik z rozwiązaniami, przejść do arkusza zadanie 1, zaznaczyć obszar odpowiedzi (czarna ramka),"]
[null,null,"c) wybrać polecenie WKLEJ SPECJALNIE, zaznaczyć opcję WARTOŚCI I FORMATY LICZB,"]
[null,null,"d) powtórzyć kroki a - c dla pozostałych zadań."]
[null,"3. Uzyskany wynik można odczytać w arkuszu Polecenia pliku z rozwiązaniami zadań."]
[]
[]
[]
[{"$f":"ADDRESS(ROW('zadanie 1'!H2),COLUMN('zadanie 1'!H2),4,1)","v":"H2"},{"$f":"ADDRESS(ROW('zadanie 1'!M13),COLUMN('zadanie 1'!M13),4,1)","v":"M13"}]
[{"$f":"ADDRESS(ROW('zadanie 2'!I2),COLUMN('zadanie 2'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 2'!N12),COLUMN('zadanie 2'!N12),4,1)","v":"N12"}]
[{"$f":"ADDRESS(ROW('zadanie 3'!H3),COLUMN('zadanie 3'!H3),4,1)","v":"H3"},{"$f":"ADDRESS(ROW('zadanie 3'!L14),COLUMN('zadanie 3'!L14),4,1)","v":"L14"}]
[{"$f":"ADDRESS(ROW('zadanie 4'!I2),COLUMN('zadanie 4'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 4'!M17),COLUMN('zadanie 4'!M17),4,1)","v":"M17"}]
[{"$f":"ADDRESS(ROW('zadanie 5'!I4),COLUMN('zadanie 5'!I4),4,1)","v":"I4"},{"$f":"ADDRESS(ROW('zadanie 5'!Q17),COLUMN('zadanie 5'!Q17),4,1)","v":"Q17"}]

{"sheet":"zadanie 1","index":1,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[10,8,10,10],[11,8,11,10],[12,8,12,10],[2,8,2,10],[3,8,3,10],[4,8,4,10],[7,8,7,10],[8,8,8,10],[9,8,9,10]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży określ składowe szeregu czasowego"]
[1,380.14,null,null,null,null,null,"a) Przeprowadź test współczynnika korelacji; α = 0,05"]
[2,361.76,null,null,null,null,null,null,"Współczynnik korelacji = "]
[3,343.59,null,null,null,null,null,null,"Statystyka testowa = "]
[4,428.92,null,null,null,null,null,null,"Wartość krytyczna  ="]
[5,369.76]
[6,364.9,null,null,null,null,null,"b) Składowe szeregu czasowego"]
[7,423.08,null,null,null,null,null,null,"Wahania przypadkowe"]
[8,412.92,null,null,null,null,null,null,"Stały poziom"]
[9,398.25,null,null,null,null,null,null,"Trend malejący"]
[10,406.07,null,null,null,null,null,null,"Trend rosnący"]
[11,371.75,null,null,null,null,null,null,"Wahania sezonowe"]
[12,405.99,null,null,null,null,null,null,"Wahania cykliczne"]
[13,397.39]
[14,435.74]
[15,435.79]
[16,421.72]
[17,418.75]
[18,446.01]
[19,404.05]
[20,434.41]
[21,423.47]
[22,480.11]
[23,445.96]
[24,452.75]
[25,419.13]
[26,436.38]
[27,432.67]
[28,474.86]
[29,486.23]
[30,499.96]
[31,457.12]
[32,429.84]
[33,470.27]
[34,507.31]
[35,492.42]
[36,467.48]
[37,464.71]
[38,499.8]
[39,533.51]
[40,491.54]
[41,496.75]
[42,472.98]
[43,504.01]
[44,504.09]
[45,516.74]
[46,526]
[47,504.98]
[48,544.70000000000005]
[49,515.11]
[50,542.34]
[51,532.95000000000005]
[52,510.79]
[53,559.4]
[54,516.1]
[55,574.29999999999995]
[56,557.6]
[57,559.28]
[58,559.71]
[59,533.66999999999996]
[60,549.29]
[61,573.88]

{"sheet":"zadanie 2","index":2,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":false,"merged":[[8,12,8,13],[2,9,2,11],[3,9,3,11],[5,9,5,11],[6,9,6,11],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży w zł wyznacz:"]
[1,15011.43,null,null,null,null,null,null,"a) parametry modelu"]
[2,14028.55,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,13821.01,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,14645.01,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[5,14705.14,null,null,null,null,null,null,null,"Współczynnik determinacji ="]
[6,15727.46,null,null,null,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[7,16356.63,null,null,null,null,null,null,"c) Uzupełnij poniższą tabelę"]
[8,14444.73,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Bezwzględny błąd prognozy ex ante","Względny błąd prognozy ex ante","Prognoza przedziałowa (p = 0,9)"]
[9,14423.8,null,null,null,null,null,null,null,null,null,null,"od","do"]
[10,16487.560000000001,null,null,null,null,null,null,101]
[11,16380.81,null,null,null,null,null,null,102]
[12,16496.599999999999]
[13,17296.82]
[14,16800.91]
[15,15640.61]
[16,15268.84]
[17,16269.89]
[18,17062.919999999998]
[19,16418.37]
[20,18811.43]
[21,17331.88]
[22,17444]
[23,16342.46]
[24,17059.3]
[25,19109.8]
[26,16436.560000000001]
[27,17674.7]
[28,18918.23]
[29,18820.62]
[30,19007.62]
[31,18250.919999999998]
[32,19393.64]
[33,18174.57]
[34,18916.900000000001]
[35,17979.11]
[36,18809.84]
[37,20415.060000000001]
[38,19013.310000000001]
[39,20003.09]
[40,19071.43]
[41,21509.52]
[42,21785.5]
[43,20905.54]
[44,19528.939999999999]
[45,19966.419999999998]
[46,21967.34]
[47,21935.4]
[48,19338.43]
[49,22643.3]
[50,22120.34]
[51,20708.810000000001]
[52,21430.51]
[53,21117.279999999999]
[54,25058.02]
[55,23467.33]
[56,22070.880000000001]
[57,22162.63]
[58,23461.66]
[59,22142.14]
[60,23833.42]
[61,24768.61]
[62,23316.63]
[63,24554.04]
[64,23415.68]
[65,23498.34]
[66,22679.18]
[67,23850.080000000002]
[68,24244.87]
[69,24953.13]
[70,23693.06]
[71,25153.53]
[72,25655.59]
[73,25440.16]
[74,24206.68]
[75,24897.1]
[76,25043.11]
[77,26059.15]
[78,25100.27]
[79,26471.43]
[80,25069.35]
[81,27223.93]
[82,27873.38]
[83,25567.19]
[84,26225.73]
[85,25603.65]
[86,27029.53]
[87,25952.94]
[88,27213.53]
[89,28189.85]
[90,27889.91]
[91,26201.4]
[92,27473.62]
[93,28348.91]
[94,29478.09]
[95,27275.26]
[96,27725.62]
[97,28616.240000000002]
[98,27773.33]
[99,29171.82]
[100,29065.23]

{"sheet":"zadanie 3","index":3,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[3,8,3,10],[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[10,8,11,8],[10,9,11,9],[10,10,11,10]]}
["Nr okresu","Sprzedaż w tys. zł",null,null,null,null,null,"Przy pomocy Solvera dokonaj optymalizacji modelu Holta przyjmując: F1 = y1, S1 = y2 – y1. "]
[1,1.9,null,null,null,null,null,"Optymalizację przeprowadź dla punktów startowych α = 0,5, β = 0,5."]
[2,5.3,null,null,null,null,null,"a) Wyznacz"]
[3,6,null,null,null,null,null,null,"α =",null,null,0.5]
[4,6.9,null,null,null,null,null,null,"β =",null,null,0.5]
[5,8.5,null,null,null,null,null,null,"s* ="]
[6,11.4,null,null,null,null,null,null,"Fn ="]
[7,11,null,null,null,null,null,null,"Sn ="]
[8,13.1]
[9,14.3,null,null,null,null,null,"b) Uzupełnij poniższą tabelę"]
[10,15.6,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Względny błąd prognozy"]
[11,19.399999999999999]
[12,20,null,null,null,null,null,null,54]
[13,22.1,null,null,null,null,null,null,55]
[14,22.6]
[15,24.5]
[16,26.1]
[17,26.9]
[18,28.2]
[19,29.6]
[20,29.8]
[21,32.6]
[22,34.200000000000003]
[23,34.4]
[24,35.799999999999997]
[25,37.9]
[26,39.1]
[27,40.6]
[28,42.5]
[29,43.9]
[30,46.6]
[31,47.5]
[32,48.9]
[33,50]
[34,50.2]
[35,54.5]
[36,53.7]
[37,56]
[38,58]
[39,60]
[40,60]
[41,61.3]
[42,64.2]
[43,64.8]
[44,66.7]
[45,67.8]
[46,68.900000000000006]
[47,69.8]
[48,71.5]
[49,73.900000000000006]
[50,74.400000000000006]
[51,77.400000000000006]
[52,77.5]
[53,80.400000000000006]

{"sheet":"zadanie 4","index":4,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,12,13,12],[2,9,2,11],[3,9,3,11],[4,9,4,11],[10,9,10,11],[12,10,13,10],[12,11,13,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie danych kwartalnych o wartości sprzedaży w zł wyznacz:"]
[1,1098.8499999999999,null,null,null,null,null,null,"a) parametry modelu"]
[2,2108.4899999999998,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,1815.55,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,2081.15,null,null,null,null,null,null,null,"wskaźniki sezonowości"]
[5,1394.11,null,null,null,null,null,null,null,null,null,"c1 ="]
[6,2168.46,null,null,null,null,null,null,null,null,null,"c2 ="]
[7,2076,null,null,null,null,null,null,null,null,null,"c3 ="]
[8,2174.4699999999998,null,null,null,null,null,null,null,null,null,"c4 ="]
[9,1503.35,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[10,2405.9699999999998,null,null,null,null,null,null,null,"Względny poziom reszt ="]
[11,2517.46,null,null,null,null,null,null,"c) Prognozy na podane okresy"]
[12,2438.9499999999998,null,null,null,null,null,null,null,null,"Nr okresu","Prognoza wstępna","Prognoza ostateczna"]
[13,1613.83]
[14,2724.59,null,null,null,null,null,null,null,null,25]
[15,2564.6,null,null,null,null,null,null,null,null,26]
[16,2894.36,null,null,null,null,null,null,null,null,27]
[17,1667.64]
[18,3053.26]
[19,2861.57]
[20,3001.18]
[21,1786.57]
[22,3391.89]
[23,3132.97]
[24,3392.69]

{"sheet":"zadanie 5","index":5,"n_rows":88,"n_cols":17,"rows_kept":88,"cut":false,"hidden":false,"merged":[[14,14,15,14],[14,15,14,16],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[4,9,4,11],[5,9,5,11],[6,9,6,11],[7,9,7,11],[10,9,10,11],[11,9,11,11]]}
["Nr okresu","Y","X1","X2","X3",null,null,null,"Na podstawie wartości zmiennych Y, X1, X2 i X3 zbuduj model ekonometryczny wyjaśniający zmienną Y"]
[1,3.6819999999999999,49.59,3.22,361.1,null,null,null,"Poziom istotności dla oceny parametrów modelu przyjmij α = 0,05"]
[2,4.1950000000000003,51.96,3.61,341.4,null,null,null,"Wyznacz"]
[3,3.3359999999999999,50.44,3.01,382.3,null,null,null,"a) parametry modelu"]
[4,5.03,63.46,4.25,318.2,null,null,null,null," α0 ="]
[5,4.8460000000000001,55.51,4.1399999999999997,310.39999999999998,null,null,null,null," α1 ="]
[6,2.02,39.090000000000003,2.13,350.6,null,null,null,null," α2 ="]
[7,3.87,51.19,3.48,350.1,null,null,null,null," α3 ="]
[8,5.3529999999999998,57.5,4.5599999999999996,246.7]
[9,3.839,50.21,3.5,287.89999999999998,null,null,null,"b) Miary dopasowania modelu"]
[10,2.9609999999999999,45.5,2.89,292.89999999999998,null,null,null,null,"Współczynnik determinacji ="]
[11,3.1560000000000001,46.06,3.05,339.4,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[12,3.5230000000000001,45.65,3.33,376.9]
[13,3.165,44.19,3.09,291.60000000000002,null,null,null,"c) Uzupełnij poniższą tabelę."]
[14,4.8220000000000001,55.63,4.3,284.39999999999998,null,null,null,"Nr okresu","Prognoza punktowa X1","Prognoza punktowa X2","Prognoza punktowa X3","Prognoza punktowa Y","Bezwzględny błąd prognozy ex ante dla Y","Względny błąd prognozy ex ante dla Y","Prognoza przedziałowa dla Y (p = 0,9)"]
[15,3.5219999999999998,37.81,3.39,339.4,null,null,null,null,null,null,null,null,null,null,"od","do"]
[16,2.6760000000000002,40.31,2.8,363.1,null,null,null,88,32.419406575781878,4.9997941726811002,217.0027800053461]
[17,3.4790000000000001,46.57,3.4,338.7]
[18,2.931,42.65,3.03,323.2]
[19,3.448,49.84,3.42,325.60000000000002]
[20,3.8370000000000002,52.03,3.72,304.60000000000002]
[21,3.383,41.9,3.41,343.2]
[22,4.2830000000000004,46.93,4.08,296.10000000000002]
[23,3.7589999999999999,45.63,3.72,307.3]
[24,2.7160000000000002,40.450000000000003,2.99,324.8]
[25,3.8119999999999998,46.96,3.8,314]
[26,3.7919999999999998,47.91,3.81,314.39999999999998]
[27,3.206,41.94,3.41,322.39999999999998]
[28,3.294,39.4,3.49,311.8]
[29,4.3600000000000003,47.08,4.2699999999999996,244.1]
[30,2.7410000000000001,39.79,3.13,330.4]
[31,2.8759999999999999,38.18,3.25,341.6]
[32,3.1859999999999999,40.130000000000003,3.49,307.3]
[33,4.6760000000000002,51.73,4.58,233.7]
[34,3.6779999999999999,45.6,3.89,350.4]
[35,3.5510000000000002,44.32,3.81,259.3]
[36,4.0069999999999997,44.21,4.16,259.39999999999998]
[37,3.7869999999999999,41.61,4.0199999999999996,294.3]
[38,3.0739999999999998,43.51,3.53,313.39999999999998]
[39,3.7189999999999999,45.37,4.0199999999999996,300.2]
[40,3.1880000000000002,38.520000000000003,3.66,297.3]
[41,4.0359999999999996,45.19,4.28,282.8]
[42,3.9830000000000001,41.13,4.2699999999999996,306.7]
[43,3.8610000000000002,49,4.2,309.89999999999998]
[44,3.5760000000000001,41.76,4.01,285.5]
[45,2.5169999999999999,35.729999999999997,3.27,262.10000000000002]
[46,4.0039999999999996,44.62,4.3600000000000003,271]
[47,4.0839999999999996,42.09,4.4400000000000004,279.8]
[48,3.8239999999999998,43.82,4.2699999999999996,231]
[49,4.7850000000000001,49.25,4.9800000000000004,223.1]
[50,5.1449999999999996,54.25,5.26,246.3]
[51,5.2569999999999997,49.24,5.36,243.1]
[52,3.121,34.97,3.85,255.3]
[53,3.4169999999999998,36.270000000000003,4.08,294.10000000000002]
[54,2.8540000000000001,32.1,3.7,275.2]
[55,3.3,34.630000000000003,4.04,230.6]
[56,2.9609999999999999,31.42,3.82,313]
[57,3.4119999999999999,41.12,4.16,242.4]
[58,3.3370000000000002,36.659999999999997,4.13,273.60000000000002]
[59,3.387,35.65,4.18,268.10000000000002]
[60,2.508,29.5,3.57,294.8]
[61,3.25,34.15,4.12,313.60000000000002]
[62,4.9489999999999998,46.16,5.36,226.7]
[63,3.8959999999999999,42.06,4.63,286.2]
[64,2.3149999999999999,27.84,3.51,292]
[65,3.794,36.229999999999997,4.59,249.5]
[66,4.5270000000000001,41.58,5.14,218.6]
[67,3.238,32.78,4.24,255.4]
[68,4.2320000000000002,39.090000000000003,4.97,216.3]
[69,3.9119999999999999,39.159999999999997,4.76,261.10000000000002]
[70,4.2830000000000004,43.97,5.05,205]
[71,3.907,32.92,4.8,178.2]
[72,3.4039999999999999,33.74,4.46,299.60000000000002]
[73,3.89,40.270000000000003,4.82,270.2]
[74,3.4089999999999998,37.020000000000003,4.5,244.7]
[75,4.0860000000000003,35.75,5.01,259.3]
[76,3.5289999999999999,32.630000000000003,4.63,246.9]
[77,2.5960000000000001,22.07,3.98,244.6]
[78,4.12,34.880000000000003,5.09,180.1]
[79,4.9489999999999998,42.79,5.71,146.9]
[80,3.6989999999999998,33,4.83,292.60000000000002]
[81,3.4950000000000001,32.79,4.7,246.7]
[82,3.605,29.86,4.8,211]
[83,3.7,36.54,4.8899999999999997,180.5]
[84,3.3809999999999998,33.06,4.68,219.3]
[85,3.504,33.93,4.79,254.1]
[86,4.0220000000000002,34.11,5.18,171.1]
[87,4.1449999999999996,34.380000000000003,5.29,241.6]